Elements - System Administrator and User Guide - On Premises
GL Export
| Administrator Guide > System Management > Recovery > GL Export |
A GL Export creates an extract file detailing the GL allocations of all transactions posted since the last extract was finalized.
From System Management, select Collection > GL Export from the GL Settings for Recovery Accounts group on the Configure tab. The GL Export page is displayed.
From the Extract drop-down, select the GL extract to export. Select Current to export all new, previously unexported GL allocations or select a previously extracted GL file to re-export.
To finalize the extract, click the Finalize check box. The GL allocations are marked with the correct export number. Export numbers start at 000001 and increase by 1 in each new extract.
 |
To generate a trial GL extract, deselect the Finalize check box. The same file can be generated multiple times until the desired results are achieved. |
When finished, click Create.
If running a trial extract, a prompt appears to open or save the file. The default name of the file is gle-current.txt.
If running a final extract, a prompt appears to open or save the file. The default name of the file includes the next sequence number (gle-000002.txt, for example), but this can be changed, if desired.
The GL file that is produced is a comma-delimited text file that includes a single record for each GL transaction. There is one GL transaction per GL account for each transaction posted against a particular loan.
The header of the file contains the following fields.
| Field | Description |
| Record Type | Fixed Value = H |
| Creation Date and Time |
Date Format = mm/dd/yyy
Time Format = hh:mm:ss using a 24 hour clock notation |
The body of the file contains the following fields.
| Field | Notes |
| Record Type | Fixed value = D |
| GL Account Number | |
| Cost Center | |
| Corporation | |
| Allocation Amount | No commas, decimal included |
| Debit/Credit Flag | Dr or Cr |
| Record Type (Trailer) | Fixed value = F |
| Number of Records (Trailer) | Total number of detail ("D") records |
| Total Amount (Trailer) | No commas, decimal included |
| Debit/Credit Flag (Trailer) | Dr or Cr |